Tabela OncologyConsultation

Definicja tabeli OncologyConsultation

Name

OncologyConsultation

Code

OncologyConsultation

Comment

Tabela do zapisu danych dotyczacych konsylium


Lista kolumn tabeli OncologyConsultation

Name

Code

OncologyConsultationID

OncologyConsultationID

OncologicCardID

OncologicCardID

IssuingOrgUnitID

IssuingOrgUnitID

InitQualityEvaluationID

InitQualityEvaluationID

DeepQualityEvaluationID

DeepQualityEvaluationID

CommentsDescrID

CommentsDescrID

TumourICDID

TumourICDID

AdvanceLevelID

AdvanceLevelID

AdvanceStageID

AdvanceStageID

SurgeonDoctorID

SurgeonDoctorID

OncologyDoctorID

OncologyDoctorID

RadiologyDoctorID

RadiologyDoctorID

RadioTherapyDoctorID

RadioTherapyDoctorID

DecisionDescrID

DecisionDescrID

FurtherProceedingID

FurtherProceedingID

ConsultationOrgUnitID

ConsultationOrgUnitID

HistopatologyICDID

HistopatologyICDID

AdvanceLevelScaleID

AdvanceLevelScaleID

WaitingListItemStartDT

WaitingListItemStartDT

ConsultationDT

ConsultationDT

MalignantTumourCardNo

MalignantTumourCardNo

KZNZCancerNotificationDT

KZNZCancerNotificationDT

AdvanceLevelScaleValue

AdvanceLevelScaleValue

HistopatologyDescrID

HistopatologyDescrID


Kolumna OncologyConsultationID tabeli OncologyConsultation

Definicja kolumny OncologyConsultationID tabeli OncologyConsultation

Name

OncologyConsultationID

Code

OncologyConsultationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna OncologicCardID tabeli OncologyConsultation

Definicja kolumny OncologicCardID tabeli OncologyConsultation

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

id karty


Kolumna IssuingOrgUnitID tabeli OncologyConsultation

Definicja kolumny IssuingOrgUnitID tabeli OncologyConsultation

Name

IssuingOrgUnitID

Code

IssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

swiadczeniodawca


Kolumna InitQualityEvaluationID tabeli OncologyConsultation

Definicja kolumny InitQualityEvaluationID tabeli OncologyConsultation

Name

InitQualityEvaluationID

Code

InitQualityEvaluationID

Data Type

NUMBER(10)

Mandatory

No

Comment

wstepna ocena diagnostyki


Kolumna DeepQualityEvaluationID tabeli OncologyConsultation

Definicja kolumny DeepQualityEvaluationID tabeli OncologyConsultation

Name

DeepQualityEvaluationID

Code

DeepQualityEvaluationID

Data Type

NUMBER(10)

Mandatory

No

Comment

poglebiona ocena diagnostyki


Kolumna CommentsDescrID tabeli OncologyConsultation

Definicja kolumny CommentsDescrID tabeli OncologyConsultation

Name

CommentsDescrID

Code

CommentsDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

uwagi


Kolumna TumourICDID tabeli OncologyConsultation

Definicja kolumny TumourICDID tabeli OncologyConsultation

Name

TumourICDID

Code

TumourICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

ICD10 nowotworu


Kolumna AdvanceLevelID tabeli OncologyConsultation

Definicja kolumny AdvanceLevelID tabeli OncologyConsultation

Name

AdvanceLevelID

Code

AdvanceLevelID

Data Type

NUMBER(10)

Mandatory

No

Comment

stopien zaawansowania


Kolumna AdvanceStageID tabeli OncologyConsultation

Definicja kolumny AdvanceStageID tabeli OncologyConsultation

Name

AdvanceStageID

Code

AdvanceStageID

Data Type

NUMBER(10)

Mandatory

No

Comment

stadium zaawansowania


Kolumna SurgeonDoctorID tabeli OncologyConsultation

Definicja kolumny SurgeonDoctorID tabeli OncologyConsultation

Name

SurgeonDoctorID

Code

SurgeonDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

chirurg


Kolumna OncologyDoctorID tabeli OncologyConsultation

Definicja kolumny OncologyDoctorID tabeli OncologyConsultation

Name

OncologyDoctorID

Code

OncologyDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

onkolog


Kolumna RadiologyDoctorID tabeli OncologyConsultation

Definicja kolumny RadiologyDoctorID tabeli OncologyConsultation

Name

RadiologyDoctorID

Code

RadiologyDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

radiolog


Kolumna RadioTherapyDoctorID tabeli OncologyConsultation

Definicja kolumny RadioTherapyDoctorID tabeli OncologyConsultation

Name

RadioTherapyDoctorID

Code

RadioTherapyDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

radioterapeuta


Kolumna DecisionDescrID tabeli OncologyConsultation

Definicja kolumny DecisionDescrID tabeli OncologyConsultation

Name

DecisionDescrID

Code

DecisionDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

decyzja


Kolumna FurtherProceedingID tabeli OncologyConsultation

Definicja kolumny FurtherProceedingID tabeli OncologyConsultation

Name

FurtherProceedingID

Code

FurtherProceedingID

Data Type

NUMBER(10)

Mandatory

No

Comment

dalsze postepowanie


Kolumna ConsultationOrgUnitID tabeli OncologyConsultation

Definicja kolumny ConsultationOrgUnitID tabeli OncologyConsultation

Name

ConsultationOrgUnitID

Code

ConsultationOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna HistopatologyICDID tabeli OncologyConsultation

Definicja kolumny HistopatologyICDID tabeli OncologyConsultation

Name

HistopatologyICDID

Code

HistopatologyICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

rozpoznanie histopatologiczne


Kolumna AdvanceLevelScaleID tabeli OncologyConsultation

Definicja kolumny AdvanceLevelScaleID tabeli OncologyConsultation

Name

AdvanceLevelScaleID

Code

AdvanceLevelScaleID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna WaitingListItemStartDT tabeli OncologyConsultation

Definicja kolumny WaitingListItemStartDT tabeli OncologyConsultation

Name

WaitingListItemStartDT

Code

WaitingListItemStartDT

Data Type

DATE

Mandatory

No

Comment

data wpisu na kolejke


Kolumna ConsultationDT tabeli OncologyConsultation

Definicja kolumny ConsultationDT tabeli OncologyConsultation

Name

ConsultationDT

Code

ConsultationDT

Data Type

DATE

Mandatory

No

Comment

data konsylium


Kolumna MalignantTumourCardNo tabeli OncologyConsultation

Definicja kolumny MalignantTumourCardNo tabeli OncologyConsultation

Name

MalignantTumourCardNo

Code

MalignantTumourCardNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

numer karty KZNZ


Kolumna KZNZCancerNotificationDT tabeli OncologyConsultation

Definicja kolumny KZNZCancerNotificationDT tabeli OncologyConsultation

Name

KZNZCancerNotificationDT

Code

KZNZCancerNotificationDT

Data Type

DATE

Mandatory

No

Comment

data zgloszenia nowotworu do KZNZ


Kolumna AdvanceLevelScaleValue tabeli OncologyConsultation

Definicja kolumny AdvanceLevelScaleValue tabeli OncologyConsultation

Name

AdvanceLevelScaleValue

Code

AdvanceLevelScaleValue

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna HistopatologyDescrID tabeli OncologyConsultation

Definicja kolumny HistopatologyDescrID tabeli OncologyConsultation

Name

HistopatologyDescrID

Code

HistopatologyDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna bedzie przechowyac dana opisowa rozpoznania histopatologicznego
(zastapi pole HistopatologyICDID)


Lista kluczy tabeli OncologyConsultation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologyConsultation

Definicja klucza Identifier_1 tabeli OncologyConsultation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment